package com.hl.shifangzhiyu.mapper;

import com.hl.shifangzhiyu.pojo.Consultant1s;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Administrator
* @description 针对表【consultant1s】的数据库操作Mapper
* @createDate 2025-06-05 14:40:04
* @Entity com.hl.shifangzhiyu.entity.Consultant1s
*/
@Mapper
public interface Consultant1sMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Consultant1s record);

    int insertSelective(Consultant1s record);

    Consultant1s selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Consultant1s record);

    int updateByPrimaryKey(Consultant1s record);

    @Select("select * from consultant1s")
    List<Consultant1s> listAll();

    @Delete("DELETE FROM consultant1s WHERE id = #{id}")
    int deleteConsultantById(Long id);

    @Insert("INSERT INTO consultant1s(name, title, description, image_url) VALUES(#{name}, #{title}, #{description}, #{imageUrl})")
    int insertConsultant(Consultant1s consultant1);
}
